[dbo].[BAEImisGetProductPrice]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEImisGetProductPrice

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@productCode	varchar(31)	31
@customerType	varchar(10)	10

SQL Script

create procedure [dbo].[BAEImisGetProductPrice] @productCode varchar(31),
@customerType varchar(10) as
SELECT * FROM Product_Price WHERE PRODUCT_CODE = @productCode AND CUSTOMER_TYPE = @customerType

GO

Uses

[dbo].[Product_Price]
dbo